package cn.cqie.attendance.manager.dao;

import cn.cqie.attendance.manager.pojo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author 697
 * @date 2021/7/8 10:48
 */
@Mapper
public interface AdminAttendanceDao {

    /**
     * 查询所有考勤记录 可组合模糊查询
     * @param adminAttendanceSerch
     * @return
     */
    List<AdminAttendance> queryAllStudentAttendanceInfo(@Param("adminAttendanceSerch") AdminAttendanceSerch adminAttendanceSerch);


    /**
     * 查询所有门禁打卡记录 可组合模糊查询
     * @param adminAttendancePunchSerch
     * @return
     */
    List<AdminAttendancePunch> queryAllPunchInfo(@Param("adminAttendancePunchSerch")AdminAttendancePunchSerch adminAttendancePunchSerch);


    /**
     * 导出门禁打卡记录
     * @return
     */
//    List<AdminAttendancePunchPutOut> exportPunchDate();


    /**
     * 导入门禁数据
     * @param adminAttendanceAdd
     * @return
     */
    int insertPunchDate(@Param("adminAttendanceAdd") AdminAttendanceAdd adminAttendanceAdd);

    /**
     * 根据学号查询学生id
     * @param stuNumber
     * @return
     */
    int queryStuIdByStuNum(@Param("stuNumber") String stuNumber);

    /**
     * 插入打卡记录
     * @param adminAttendancePunch
     * @return
     */
    int insertPunchRecord(@Param("adminAttendancePunch")AdminAttendancePunch adminAttendancePunch);

    /**
     * 根据学生id查询他的课程信息
     * @param stuId
     * @return
     */
    List<AdminStuCourseLeaves> queryStudentCourseById(@Param("stuId") Integer stuId);
}
